# -*- coding: utf-8 -*-#
#-------------------------------------------------------------------------------
# 建立者:        潘炎珍  
# Name:         test03
# Description:
# Author:       98745
# Date:         2019/4/20
#-------------------------------------------------------------------------------

import sqlite3
import os
dbpath='./db/mydb.sqlite'
if not os.path.exists(dbpath):
    conn=sqlite3.connect(dbpath)
    c=conn.cursor()
    sql='''create table person(id int primary key,name text not null,age int not null);'''
    c.execute(sql)
    conn.commit()
    conn.close()